UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBTt3NfFGTevs6ZJUmzMy1a840S4gk9SDl0aiPbMbag='
WHERE
key_id = '5770703b98de1d796bca8800a8b8513ada22f8f1355d227894575c05181ba6fb'
AND (
token = 'xBTt3NfFGTevs6ZJUmzMy1a840S4gk9SDl0aiPbMbag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)