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