UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xMRqKOjacVYQ+snxFxZoR0psun3cVRPffLzA3LO1Poc='
WHERE
key_id = 'bc5f256b03a7b844d9b4ee6157ca604888809a5a2f5d9b66b0a60d3b47ced4f9'
AND (
token = 'xMRqKOjacVYQ+snxFxZoR0psun3cVRPffLzA3LO1Poc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)