UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfAr3K6bDgZlrp7aqbkS6DHJcO1e6hjbIv/UhpqCQaE='
WHERE
key_id = 'e2b45b39105032a504642a4e809dcb540bded48ea5aee22969b469a758ff03ef'
AND (
token = 'xfAr3K6bDgZlrp7aqbkS6DHJcO1e6hjbIv/UhpqCQaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)