UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5smpXV7v8bqwiu/YFEDXGjFKtt9MUEkMCNV8BoI31p8='
WHERE
key_id = '04df8edf4207f548cb15dfd1532d515b48a2fcb8eab568ae6273ffc49334102e'
AND (
token = '5smpXV7v8bqwiu/YFEDXGjFKtt9MUEkMCNV8BoI31p8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)