UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6K1ONeXFOD+NqFA0OaqQSz5dBE6WiRBHozw5mAJNYA='
WHERE
key_id = '9f4e85e9524e08a4e1d905852138551b86827ab54dd22aed0711fb4955c9f259'
AND (
token = 'i6K1ONeXFOD+NqFA0OaqQSz5dBE6WiRBHozw5mAJNYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)