UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PdyAlEH5d8S39Jy5Vra3uHENEcWqzpcD6FH3p7rQayc='
WHERE
key_id = '116a7df317f5194e3b444375daedad59d4921a29cf12a97f871cc8c068ce9892'
AND (
token = 'PdyAlEH5d8S39Jy5Vra3uHENEcWqzpcD6FH3p7rQayc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)