UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JSu5xKU7MaVtcpLFBToo22AcKgjNzjbGl8T6oW3E+Wc='
WHERE
key_id = 'bbae5cc89894f369efcb56d5d7981d9e92f664cc2896b1534d37cf6dc48bc17e'
AND (
token = 'JSu5xKU7MaVtcpLFBToo22AcKgjNzjbGl8T6oW3E+Wc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)