UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8vDKhr4h9nzlrOtGhzKsiNQiBeE6EMVBxTFa5UZ5bjs='
WHERE
key_id = '10f26fbe66a6920aec915f6f422e15484625b747b6f58be12d59da0ac7e14929'
AND (
token = '8vDKhr4h9nzlrOtGhzKsiNQiBeE6EMVBxTFa5UZ5bjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)