UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcQRLPznafAnc5FkjS+Z1kf5z93VmI9mGkyLyOKl+lA='
WHERE
key_id = 'b8966bb82a4bd970ffda6d36bcfe49db26c542025e9306abfc6732c229072668'
AND (
token = 'XcQRLPznafAnc5FkjS+Z1kf5z93VmI9mGkyLyOKl+lA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)