UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qhDd1rLV1bjoQCRfWQgw+K9U0fn77w8VqplcSAAcGw='
WHERE
key_id = '1f3408eb5a39e1b02b11a6f5a0daf9f358ef9c3870dd0a8741a28593b7ec5a82'
AND (
token = '9qhDd1rLV1bjoQCRfWQgw+K9U0fn77w8VqplcSAAcGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)