UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MnXnvKjojSrG7blimkdL5dVdk5qWWWQWOYAlCaITrmE='
WHERE
key_id = 'c2af1f66c42d5cc8f3341fa3604c87ebb1852492f125a04c67af1af44e01ea89'
AND (
token = 'MnXnvKjojSrG7blimkdL5dVdk5qWWWQWOYAlCaITrmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)