UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YIPwCWeQ3i5OLJiHy+agVN5s2d1MmVpjEglbS3lVns='
WHERE
key_id = 'a29e9b6afab72ff97da05b602dfc2814c9750b12caf7d8138d7ae8ff5718ef3c'
AND (
token = '1YIPwCWeQ3i5OLJiHy+agVN5s2d1MmVpjEglbS3lVns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)