UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ntfWrsQHXf68fhnRKbWxUZL7cTvzSm9xs1ZG28xFLSo='
WHERE
key_id = 'bc077a649a6cb484560244279be7d6b45ba6899e58d7670d66c204847d3a2db7'
AND (
token = 'ntfWrsQHXf68fhnRKbWxUZL7cTvzSm9xs1ZG28xFLSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)