UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDEH5rE2fvAAndL8EqI4iv3nNDTm1SWex36vQeO6MG0='
WHERE
key_id = '7123fcb8731d6d29b212a69512f9a0950c84b2f1120bb726fee81f5b082114f9'
AND (
token = 'pDEH5rE2fvAAndL8EqI4iv3nNDTm1SWex36vQeO6MG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)