UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZ17lZg15pPjb6PSn039li/90hMXzDIzBsg1QxK5ALA='
WHERE
key_id = 'dda16164202496d63a7b9e4c863e78a3d474b06c2b3c972ee1759bb111f97f03'
AND (
token = 'zZ17lZg15pPjb6PSn039li/90hMXzDIzBsg1QxK5ALA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)