UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hc8mcXFvD6h0zk7HNFj8wGEGg7d2TkipjNsfZrh3XcQ='
WHERE
key_id = '3971da8cb3d4223ee652405abaa53627723de4c4651cbc906274dbde38062740'
AND (
token = 'Hc8mcXFvD6h0zk7HNFj8wGEGg7d2TkipjNsfZrh3XcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)