UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pr5xP6PR0xCxkcDMUAgyxfiDs7ngmMyrn5p9seK8m0g='
WHERE
key_id = '242178f3c41fca516662f40c92d36a57f52effb34619f42a5ddd91d8fefe83b3'
AND (
token = 'pr5xP6PR0xCxkcDMUAgyxfiDs7ngmMyrn5p9seK8m0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)