UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9FhScLW+lRyglz2XS6ddzL6DzoySq/i4vFCgl6mSWgo='
WHERE
key_id = '22a6155a1b56188f0998f3f94ec1154a659f48e488eaafa81e9f28b9185f5d27'
AND (
token = '9FhScLW+lRyglz2XS6ddzL6DzoySq/i4vFCgl6mSWgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)