UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lT+b5WSNHEvqn3gzYsw/120pDgcePPf81n4yCt/dAU='
WHERE
key_id = '46b90ca37aaac84dda85cf7369fb7de7f60845f519708b9694879652d2a8dbe2'
AND (
token = '/lT+b5WSNHEvqn3gzYsw/120pDgcePPf81n4yCt/dAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)