UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPIL8sJmpjVz22I8F5JDWXbRE91fyNBFjJSF8i+Y1rY='
WHERE
key_id = '8fa795d8cd8055a2630a37e726fd8bc1d336b3f38c74f533faf8643b0210b8be'
AND (
token = 'gPIL8sJmpjVz22I8F5JDWXbRE91fyNBFjJSF8i+Y1rY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)