UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YG+drvZn4wVT7fopWMOBRUfRIMHaVGOJxDl7K14fkiw='
WHERE
key_id = 'fc83b7c5286696bc670c0942e323ae3a9dfe36ab97073443e7d7634430e7778d'
AND (
token = 'YG+drvZn4wVT7fopWMOBRUfRIMHaVGOJxDl7K14fkiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)