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