UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MdiRvKbddjQF47BiOgwkZxwEthYRQXb7BwtJab1BWQk='
WHERE
key_id = '6adda19277dd7433c3510b8f3ab41c285cf347b10daf6892a092eb9c41fc3e00'
AND (
token = 'MdiRvKbddjQF47BiOgwkZxwEthYRQXb7BwtJab1BWQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)