UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7BhTDWrWuFBWrFgb+lcrFNXujSc3niXSIhBXf8DTuA='
WHERE
key_id = 'd8ef77d8f89a7e527a5ec5b6895926211148bea7b2d511f151f96d3cf9756ef7'
AND (
token = 'D7BhTDWrWuFBWrFgb+lcrFNXujSc3niXSIhBXf8DTuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)