UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ddYSWZPWlpBWalYxJKsZXDmjygGOg17Zxgz6yzc4gRo='
WHERE
key_id = '233172d54ab8319c727d549f2999238e044267d3d7008f24feee721e852841e3'
AND (
token = 'ddYSWZPWlpBWalYxJKsZXDmjygGOg17Zxgz6yzc4gRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)