UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GB624z2u2WLNQuTDqxVSyrleDtVPGanXo2yEpQO/eHU='
WHERE
key_id = 'dd4e683d80a8177a32a9a6d940e7879cf795215ca5479fbb23de480b2841165c'
AND (
token = 'GB624z2u2WLNQuTDqxVSyrleDtVPGanXo2yEpQO/eHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)