UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2BUaPahTpQjrIiWu4JQV0crkq8dgT0Gd4zHlrB2qG98='
WHERE
key_id = '787d621af1c064da5e3d89d37369b45c9ecd7cac212204b106353ad3ae5c4eec'
AND (
token = '2BUaPahTpQjrIiWu4JQV0crkq8dgT0Gd4zHlrB2qG98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)