UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BX62aHCujGp+LOvIe+WcKirnPwXZ5K4yfF2hyCkqpP4='
WHERE
key_id = '9e4fe0f5874602c8c97b4779f15c9f1caf91bc07aaf231fe8c50abe076f230f6'
AND (
token = 'BX62aHCujGp+LOvIe+WcKirnPwXZ5K4yfF2hyCkqpP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)