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