UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kBHmm5lDTPVt9AugfaMqZq/p3wqdytXptJ9tWrqOC6U='
WHERE
key_id = 'f5932404d2e2c97281e31e68448e688a20b55fd1942f1284d68dab4cbaa6bf56'
AND (
token = 'kBHmm5lDTPVt9AugfaMqZq/p3wqdytXptJ9tWrqOC6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)