UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tX2AoZXOcj9YpS5PR0fclzmzRCuMs9I4BYMkUsbnDM4='
WHERE
key_id = '9181ad0b7a61a111b1c55f4b1f2e29e49332e081ca420249a28ec7df6976195e'
AND (
token = 'tX2AoZXOcj9YpS5PR0fclzmzRCuMs9I4BYMkUsbnDM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)