UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IrkIjlTr4U3dlSMhrkZ7/HoCson2kMF90qCo0Z77uN8='
WHERE
key_id = 'a1f9edc8c0509ac17ab35aa5d531b826afa78db16cdbb6a39015cfc927677353'
AND (
token = 'IrkIjlTr4U3dlSMhrkZ7/HoCson2kMF90qCo0Z77uN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)