UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mWZwEjaTiPpnQa6CH+NVYp3DhTMi9p+McS6wSViizxU='
WHERE
key_id = '47df6528c3ee1224c9ccc11916365ca8b0aa767276ca92504eb3bf89beead30d'
AND (
token = 'mWZwEjaTiPpnQa6CH+NVYp3DhTMi9p+McS6wSViizxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)