UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3TA0EzomiJcBn3Rs/+IZ/4edBdWaHd4eZjVTFr+FphU='
WHERE
key_id = '38a8e0ee60856e6074e2b6a0f902d42c7f84c0c1120a9a06c5f6b9906dd80a52'
AND (
token = '3TA0EzomiJcBn3Rs/+IZ/4edBdWaHd4eZjVTFr+FphU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)