UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZ6JPpBSfK7+rpTmjK2lByfZy4etlroncvV7t1gLIyg='
WHERE
key_id = '9ff624658b8712eb58280afc5a8f3483462db444dbd8df4a9818efe2bd7e65c6'
AND (
token = 'qZ6JPpBSfK7+rpTmjK2lByfZy4etlroncvV7t1gLIyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)