UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mDHTQM8aRoKp3uyyv5tJ94VCZw88byJOV5X7Y0SgA+8='
WHERE
key_id = '5a63e132f14f3cd64c60455929e6e07afe699914b540bc34022f49a800d3ecf9'
AND (
token = 'mDHTQM8aRoKp3uyyv5tJ94VCZw88byJOV5X7Y0SgA+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)