UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PjWaasyqC18JgA7R23JGfNNi+gqlzqfAV/rq2xXBl3Y='
WHERE
key_id = '1c4c18869ac9cbefb5b53e6b04ca07e285729156c33feaac396e04d08bf235d4'
AND (
token = 'PjWaasyqC18JgA7R23JGfNNi+gqlzqfAV/rq2xXBl3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)