UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bJfl5m0z9xdsbg8/qLEleNHX8bMm9LRImqJWBIjV2U8='
WHERE
key_id = 'aa55a058e9cabc5df98ebc8cb5833de62dffa787eae6df28429eb6e8cfd31c39'
AND (
token = 'bJfl5m0z9xdsbg8/qLEleNHX8bMm9LRImqJWBIjV2U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)