UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vv3goHhSfMsAi5CSQsxGSBAIpRtVrsNIB5396U27aCs='
WHERE
key_id = '3e218af3ffd3f7612bc6dba79a9dcbcc3967580c9479d97891f7ec5cef4df866'
AND (
token = 'Vv3goHhSfMsAi5CSQsxGSBAIpRtVrsNIB5396U27aCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)