UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1V/GxwnGwj42b3ct43eySy72nrzANmCBWe/R1HybF8='
WHERE
key_id = '06b0ca7f73f749075fc43451ee0cb4f7fe2dcf9c350f96ed29102f909e156543'
AND (
token = 'x1V/GxwnGwj42b3ct43eySy72nrzANmCBWe/R1HybF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)